Overview

Dataset statistics

Number of variables18
Number of observations10496
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 MiB
Average record size in memory136.0 B

Variable types

Numeric11
Boolean3
Categorical4

Alerts

df_index is highly correlated with UserID and 1 other fieldsHigh correlation
UserID is highly correlated with df_index and 1 other fieldsHigh correlation
Yearly_avg_view_on_travel_page is highly correlated with Daily_Avg_mins_spend_on_traveling_pageHigh correlation
total_likes_on_outofstation_checkin_received is highly correlated with Daily_Avg_mins_spend_on_traveling_pageHigh correlation
montly_avg_comment_on_company_page is highly correlated with df_index and 1 other fieldsHigh correlation
Daily_Avg_mins_spend_on_traveling_page is highly correlated with Yearly_avg_view_on_travel_page and 1 other fieldsHigh correlation
df_index is highly correlated with UserID and 1 other fieldsHigh correlation
UserID is highly correlated with df_index and 1 other fieldsHigh correlation
Yearly_avg_view_on_travel_page is highly correlated with total_likes_on_outofstation_checkin_received and 1 other fieldsHigh correlation
total_likes_on_outofstation_checkin_received is highly correlated with Yearly_avg_view_on_travel_page and 1 other fieldsHigh correlation
montly_avg_comment_on_company_page is highly correlated with df_index and 1 other fieldsHigh correlation
Daily_Avg_mins_spend_on_traveling_page is highly correlated with Yearly_avg_view_on_travel_page and 1 other fieldsHigh correlation
df_index is highly correlated with UserIDHigh correlation
UserID is highly correlated with df_indexHigh correlation
df_index is highly correlated with UserID and 2 other fieldsHigh correlation
UserID is highly correlated with df_index and 2 other fieldsHigh correlation
Yearly_avg_view_on_travel_page is highly correlated with total_likes_on_outofstation_checkin_received and 1 other fieldsHigh correlation
preferred_location_type is highly correlated with df_index and 1 other fieldsHigh correlation
total_likes_on_outofstation_checkin_received is highly correlated with Yearly_avg_view_on_travel_page and 1 other fieldsHigh correlation
montly_avg_comment_on_company_page is highly correlated with df_index and 2 other fieldsHigh correlation
working_flag is highly correlated with montly_avg_comment_on_company_pageHigh correlation
Daily_Avg_mins_spend_on_traveling_page is highly correlated with Yearly_avg_view_on_travel_page and 1 other fieldsHigh correlation
df_index has unique values Unique
UserID has unique values Unique
week_since_last_outstation_checkin has 917 (8.7%) zeros Zeros

Reproduction

Analysis started2022-05-01 03:47:49.202366
Analysis finished2022-05-01 03:48:15.421813
Duration26.22 seconds
Software versionpandas-profiling v3.1.0
Download configurationconfig.json

Variables

df_index
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct10496
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6265.490949
Minimum0
Maximum11759
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size82.1 KiB
2022-05-01T09:18:15.533814image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile706.75
Q13435.75
median6511.5
Q39135.25
95-th percentile11234.25
Maximum11759
Range11759
Interquartile range (IQR)5699.5

Descriptive statistics

Standard deviation3345.361909
Coefficient of variation (CV)0.533934521
Kurtosis-1.138692635
Mean6265.490949
Median Absolute Deviation (MAD)2822
Skewness-0.1580828039
Sum65762593
Variance11191446.3
MonotonicityStrictly increasing
2022-05-01T09:18:15.727774image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
01
 
< 0.1%
7571
 
< 0.1%
48551
 
< 0.1%
110001
 
< 0.1%
89531
 
< 0.1%
28121
 
< 0.1%
7651
 
< 0.1%
69101
 
< 0.1%
48631
 
< 0.1%
110081
 
< 0.1%
Other values (10486)10486
99.9%
ValueCountFrequency (%)
01
< 0.1%
11
< 0.1%
21
< 0.1%
31
< 0.1%
41
< 0.1%
51
< 0.1%
81
< 0.1%
101
< 0.1%
111
< 0.1%
121
< 0.1%
ValueCountFrequency (%)
117591
< 0.1%
117581
< 0.1%
117571
< 0.1%
117561
< 0.1%
117551
< 0.1%
117541
< 0.1%
117531
< 0.1%
117521
< 0.1%
117511
< 0.1%
117501
< 0.1%

UserID
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct10496
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1006266.491
Minimum1000001
Maximum1011760
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size82.1 KiB
2022-05-01T09:18:15.926818image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum1000001
5-th percentile1000707.75
Q11003436.75
median1006512.5
Q31009136.25
95-th percentile1011235.25
Maximum1011760
Range11759
Interquartile range (IQR)5699.5

Descriptive statistics

Standard deviation3345.361909
Coefficient of variation (CV)0.003324528779
Kurtosis-1.138692635
Mean1006266.491
Median Absolute Deviation (MAD)2822
Skewness-0.1580828039
Sum1.056177309 × 1010
Variance11191446.3
MonotonicityStrictly increasing
2022-05-01T09:18:16.133774image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10031721
 
< 0.1%
10082881
 
< 0.1%
10060101
 
< 0.1%
10090291
 
< 0.1%
10112911
 
< 0.1%
10116081
 
< 0.1%
10089801
 
< 0.1%
10051921
 
< 0.1%
10074411
 
< 0.1%
10029361
 
< 0.1%
Other values (10486)10486
99.9%
ValueCountFrequency (%)
10000011
< 0.1%
10000021
< 0.1%
10000031
< 0.1%
10000041
< 0.1%
10000051
< 0.1%
10000061
< 0.1%
10000091
< 0.1%
10000111
< 0.1%
10000121
< 0.1%
10000131
< 0.1%
ValueCountFrequency (%)
10117601
< 0.1%
10117591
< 0.1%
10117581
< 0.1%
10117571
< 0.1%
10117561
< 0.1%
10117551
< 0.1%
10117541
< 0.1%
10117531
< 0.1%
10117521
< 0.1%
10117511
< 0.1%

Buy_ticket
Boolean

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size10.4 KiB
False
8794 
True
1702 
ValueCountFrequency (%)
False8794
83.8%
True1702
 
16.2%
2022-05-01T09:18:16.279811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Yearly_avg_view_on_travel_page
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct330
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean281.2844893
Minimum92.5
Maximum464
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size82.1 KiB
2022-05-01T09:18:16.409811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum92.5
5-th percentile182
Q1232
median271
Q3325
95-th percentile410
Maximum464
Range371.5
Interquartile range (IQR)93

Descriptive statistics

Standard deviation68.15326205
Coefficient of variation (CV)0.2422929974
Kurtosis-0.3657891531
Mean281.2844893
Median Absolute Deviation (MAD)45
Skewness0.4270026329
Sum2952362
Variance4644.867129
MonotonicityNot monotonic
2022-05-01T09:18:16.601779image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
255169
 
1.6%
262163
 
1.6%
270160
 
1.5%
232137
 
1.3%
217137
 
1.3%
247123
 
1.2%
240120
 
1.1%
225118
 
1.1%
285117
 
1.1%
264116
 
1.1%
Other values (320)9136
87.0%
ValueCountFrequency (%)
92.58
0.1%
1353
 
< 0.1%
1368
0.1%
1376
 
0.1%
1383
 
< 0.1%
1402
 
< 0.1%
1413
 
< 0.1%
1424
 
< 0.1%
1437
 
0.1%
14419
0.2%
ValueCountFrequency (%)
4641
 
< 0.1%
4631
 
< 0.1%
4622
 
< 0.1%
4612
 
< 0.1%
4603
< 0.1%
4592
 
< 0.1%
4581
 
< 0.1%
4573
< 0.1%
4565
< 0.1%
4557
0.1%

preferred_device
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size82.1 KiB
Mobile
9388 
Laptop
1108 

Length

Max length6
Median length6
Mean length6
Min length6

Characters and Unicode

Total characters0
Distinct characters0
Distinct categories0 ?
Distinct scripts0 ?
Distinct blocks0 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowMobile
2nd rowMobile
3rd rowMobile
4th rowMobile
5th rowMobile

Common Values

ValueCountFrequency (%)
Mobile9388
89.4%
Laptop1108
 
10.6%

Length

2022-05-01T09:18:16.800813image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram of lengths of the category

Pie chart

2022-05-01T09:18:16.902813image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
ValueCountFrequency (%)
mobile9388
89.4%
laptop1108
 
10.6%

Most occurring characters

ValueCountFrequency (%)
No values found.

Most occurring categories

ValueCountFrequency (%)
No values found.

Most frequent character per category

Most occurring scripts

ValueCountFrequency (%)
No values found.

Most frequent character per script

Most occurring blocks

ValueCountFrequency (%)
No values found.

Most frequent character per block

Distinct7565
Distinct (%)72.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28155.04268
Minimum3570
Maximum76841
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size82.1 KiB
2022-05-01T09:18:17.044778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum3570
5-th percentile5748
Q116321
median28178
Q340529.25
95-th percentile49881.5
Maximum76841
Range73271
Interquartile range (IQR)24208.25

Descriptive statistics

Standard deviation14119.85805
Coefficient of variation (CV)0.5015036989
Kurtosis-1.180383428
Mean28155.04268
Median Absolute Deviation (MAD)12009
Skewness-0.005701374773
Sum295515328
Variance199370391.3
MonotonicityNot monotonic
2022-05-01T09:18:17.256810image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1151511
 
0.1%
185509
 
0.1%
378709
 
0.1%
241859
 
0.1%
401108
 
0.1%
449058
 
0.1%
514157
 
0.1%
201257
 
0.1%
313257
 
0.1%
404957
 
0.1%
Other values (7555)10414
99.2%
ValueCountFrequency (%)
35702
< 0.1%
35771
< 0.1%
35781
< 0.1%
36052
< 0.1%
36111
< 0.1%
36141
< 0.1%
36181
< 0.1%
36201
< 0.1%
36211
< 0.1%
36311
< 0.1%
ValueCountFrequency (%)
768412
< 0.1%
525121
< 0.1%
525091
< 0.1%
524981
< 0.1%
524951
< 0.1%
524871
< 0.1%
524791
< 0.1%
524741
< 0.1%
524691
< 0.1%
524651
< 0.1%

yearly_avg_Outstation_checkins
Real number (ℝ≥0)

Distinct29
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.282869665
Minimum1
Maximum29
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size41.1 KiB
2022-05-01T09:18:17.464803image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median5
Q314
95-th percentile26
Maximum29
Range28
Interquartile range (IQR)13

Descriptive statistics

Standard deviation8.567258547
Coefficient of variation (CV)1.034334584
Kurtosis-0.3412692429
Mean8.282869665
Median Absolute Deviation (MAD)4
Skewness0.9699234679
Sum86937
Variance73.39791901
MonotonicityNot monotonic
2022-05-01T09:18:17.737819image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
13794
36.1%
2844
 
8.0%
10617
 
5.9%
9340
 
3.2%
7336
 
3.2%
3336
 
3.2%
8320
 
3.0%
5261
 
2.5%
4256
 
2.4%
6236
 
2.2%
Other values (19)3156
30.1%
ValueCountFrequency (%)
13794
36.1%
2844
 
8.0%
3336
 
3.2%
4256
 
2.4%
5261
 
2.5%
6236
 
2.2%
7336
 
3.2%
8320
 
3.0%
9340
 
3.2%
10617
 
5.9%
ValueCountFrequency (%)
29184
1.8%
28160
1.5%
2789
0.8%
26172
1.6%
25172
1.6%
24201
1.9%
23189
1.8%
22133
1.3%
21133
1.3%
20172
1.6%

member_in_family
Real number (ℝ≥0)

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.924828506
Minimum1
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size41.1 KiB
2022-05-01T09:18:17.905777image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q34
95-th percentile4
Maximum10
Range9
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.042118709
Coefficient of variation (CV)0.3563007907
Kurtosis1.278422445
Mean2.924828506
Median Absolute Deviation (MAD)1
Skewness-0.00321649857
Sum30699
Variance1.086011405
MonotonicityNot monotonic
2022-05-01T09:18:18.035810image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
34109
39.1%
42858
27.2%
21989
19.0%
11197
 
11.4%
5333
 
3.2%
1010
 
0.1%
ValueCountFrequency (%)
11197
 
11.4%
21989
19.0%
34109
39.1%
42858
27.2%
5333
 
3.2%
1010
 
0.1%
ValueCountFrequency (%)
1010
 
0.1%
5333
 
3.2%
42858
27.2%
34109
39.1%
21989
19.0%
11197
 
11.4%

preferred_location_type
Categorical

HIGH CORRELATION

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size82.1 KiB
Beach
2424 
Financial
1893 
Historical site
1856 
Medical
1463 
Other
1307 
Other values (2)
1553 

Length

Max length15
Median length8
Mean length8.649199695
Min length5

Characters and Unicode

Total characters0
Distinct characters0
Distinct categories0 ?
Distinct scripts0 ?
Distinct blocks0 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowFinancial
2nd rowFinancial
3rd rowOther
4th rowFinancial
5th rowMedical

Common Values

ValueCountFrequency (%)
Beach2424
23.1%
Financial1893
18.0%
Historical site1856
17.7%
Medical1463
13.9%
Other1307
12.5%
Entertainment917
 
8.7%
Trekking636
 
6.1%

Length

2022-05-01T09:18:18.207813image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram of lengths of the category

Pie chart

2022-05-01T09:18:18.326777image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
ValueCountFrequency (%)
beach2424
19.6%
financial1893
15.3%
historical1856
15.0%
site1856
15.0%
medical1463
11.8%
other1307
10.6%
entertainment917
 
7.4%
trekking636
 
5.1%

Most occurring characters

ValueCountFrequency (%)
No values found.

Most occurring categories

ValueCountFrequency (%)
No values found.

Most frequent character per category

Most occurring scripts

ValueCountFrequency (%)
No values found.

Most frequent character per script

Most occurring blocks

ValueCountFrequency (%)
No values found.

Most frequent character per block

Distinct97
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean75.02238948
Minimum3
Maximum147
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size82.1 KiB
2022-05-01T09:18:18.553779image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile41
Q157
median75
Q393
95-th percentile109
Maximum147
Range144
Interquartile range (IQR)36

Descriptive statistics

Standard deviation21.78264525
Coefficient of variation (CV)0.2903485932
Kurtosis-0.7375029978
Mean75.02238948
Median Absolute Deviation (MAD)18
Skewness-0.07411929514
Sum787435
Variance474.483634
MonotonicityNot monotonic
2022-05-01T09:18:18.743811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
96175
 
1.7%
90173
 
1.6%
66171
 
1.6%
56169
 
1.6%
72167
 
1.6%
80166
 
1.6%
60163
 
1.6%
91161
 
1.5%
87160
 
1.5%
61159
 
1.5%
Other values (87)8832
84.1%
ValueCountFrequency (%)
329
0.3%
3124
 
0.2%
3243
0.4%
3334
0.3%
3435
0.3%
3539
0.4%
3649
0.5%
3744
0.4%
3860
0.6%
3957
0.5%
ValueCountFrequency (%)
1473
 
< 0.1%
1257
 
0.1%
1243
 
< 0.1%
1238
 
0.1%
12210
 
0.1%
12111
0.1%
12010
 
0.1%
11924
0.2%
11824
0.2%
11725
0.2%

total_likes_on_outofstation_checkin_received
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct5323
Distinct (%)50.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6393.061928
Minimum1009
Maximum16574.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size82.1 KiB
2022-05-01T09:18:18.942811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum1009
5-th percentile2136
Q12948.5
median4948
Q38398.25
95-th percentile16574.5
Maximum16574.5
Range15565.5
Interquartile range (IQR)5449.75

Descriptive statistics

Standard deviation4344.08664
Coefficient of variation (CV)0.6795001658
Kurtosis0.2920306832
Mean6393.061928
Median Absolute Deviation (MAD)2192
Skewness1.164642767
Sum67101578
Variance18871088.74
MonotonicityNot monotonic
2022-05-01T09:18:19.121814image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
16574.5822
 
7.8%
237711
 
0.1%
24049
 
0.1%
23429
 
0.1%
24379
 
0.1%
23878
 
0.1%
23808
 
0.1%
25708
 
0.1%
20968
 
0.1%
27938
 
0.1%
Other values (5313)9596
91.4%
ValueCountFrequency (%)
10092
< 0.1%
10141
< 0.1%
10171
< 0.1%
10501
< 0.1%
10511
< 0.1%
10522
< 0.1%
10551
< 0.1%
10581
< 0.1%
10601
< 0.1%
10612
< 0.1%
ValueCountFrequency (%)
16574.5822
7.8%
165671
 
< 0.1%
165611
 
< 0.1%
165051
 
< 0.1%
164951
 
< 0.1%
164911
 
< 0.1%
164871
 
< 0.1%
164811
 
< 0.1%
164801
 
< 0.1%
164771
 
< 0.1%

week_since_last_outstation_checkin
Real number (ℝ≥0)

ZEROS

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.20788872
Minimum0
Maximum11
Zeros917
Zeros (%)8.7%
Negative0
Negative (%)0.0%
Memory size82.1 KiB
2022-05-01T09:18:19.304779image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median3
Q35
95-th percentile9
Maximum11
Range11
Interquartile range (IQR)4

Descriptive statistics

Standard deviation2.614220407
Coefficient of variation (CV)0.8149348796
Kurtosis-0.04186660285
Mean3.20788872
Median Absolute Deviation (MAD)2
Skewness0.9118567761
Sum33670
Variance6.834148339
MonotonicityNot monotonic
2022-05-01T09:18:19.446778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
12733
26.0%
31605
15.3%
21502
14.3%
4993
 
9.5%
0917
 
8.7%
5643
 
6.1%
6585
 
5.6%
7545
 
5.2%
9410
 
3.9%
8384
 
3.7%
Other values (2)179
 
1.7%
ValueCountFrequency (%)
0917
 
8.7%
12733
26.0%
21502
14.3%
31605
15.3%
4993
 
9.5%
5643
 
6.1%
6585
 
5.6%
7545
 
5.2%
8384
 
3.7%
9410
 
3.9%
ValueCountFrequency (%)
1154
 
0.5%
10125
 
1.2%
9410
 
3.9%
8384
 
3.7%
7545
 
5.2%
6585
 
5.6%
5643
6.1%
4993
9.5%
31605
15.3%
21502
14.3%
Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size10.4 KiB
False
7548 
True
2948 
ValueCountFrequency (%)
False7548
71.9%
True2948
 
28.1%
2022-05-01T09:18:19.557815image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

montly_avg_comment_on_company_page
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct33
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.35832698
Minimum11
Maximum43
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size82.1 KiB
2022-05-01T09:18:19.675774image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum11
5-th percentile12
Q118
median23
Q328
95-th percentile37
Maximum43
Range32
Interquartile range (IQR)10

Descriptive statistics

Standard deviation7.394584451
Coefficient of variation (CV)0.3165716644
Kurtosis-0.142551385
Mean23.35832698
Median Absolute Deviation (MAD)5
Skewness0.4775176118
Sum245169
Variance54.6798792
MonotonicityNot monotonic
2022-05-01T09:18:19.846778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
23620
 
5.9%
22574
 
5.5%
24552
 
5.3%
25548
 
5.2%
20527
 
5.0%
21519
 
4.9%
19500
 
4.8%
18494
 
4.7%
26476
 
4.5%
17439
 
4.2%
Other values (23)5247
50.0%
ValueCountFrequency (%)
11321
3.1%
12325
3.1%
13312
3.0%
14379
3.6%
15301
2.9%
16346
3.3%
17439
4.2%
18494
4.7%
19500
4.8%
20527
5.0%
ValueCountFrequency (%)
43213
2.0%
4227
 
0.3%
4130
 
0.3%
4046
 
0.4%
3973
 
0.7%
3891
0.9%
3777
 
0.7%
36119
1.1%
35175
1.7%
34177
1.7%

working_flag
Boolean

HIGH CORRELATION

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size10.4 KiB
False
8884 
True
1612 
ValueCountFrequency (%)
False8884
84.6%
True1612
 
15.4%
2022-05-01T09:18:19.984774image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size82.1 KiB
3.0
3309 
4.0
3072 
2.0
2157 
1.0
1958 

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters0
Distinct characters0
Distinct categories0 ?
Distinct scripts0 ?
Distinct blocks0 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1.0
2nd row4.0
3rd row2.0
4th row3.0
5th row4.0

Common Values

ValueCountFrequency (%)
3.03309
31.5%
4.03072
29.3%
2.02157
20.6%
1.01958
18.7%

Length

2022-05-01T09:18:20.100811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram of lengths of the category

Pie chart

2022-05-01T09:18:20.207812image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
ValueCountFrequency (%)
3.03309
31.5%
4.03072
29.3%
2.02157
20.6%
1.01958
18.7%

Most occurring characters

ValueCountFrequency (%)
No values found.

Most occurring categories

ValueCountFrequency (%)
No values found.

Most frequent character per category

Most occurring scripts

ValueCountFrequency (%)
No values found.

Most frequent character per script

Most occurring blocks

ValueCountFrequency (%)
No values found.

Most frequent character per block

number_of_adults
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size82.1 KiB
0.0
4497 
1.0
4265 
2.0
1115 
2.5
619 

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters0
Distinct characters0
Distinct categories0 ?
Distinct scripts0 ?
Distinct blocks0 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0.0
2nd row1.0
3rd row0.0
4th row0.0
5th row1.0

Common Values

ValueCountFrequency (%)
0.04497
42.8%
1.04265
40.6%
2.01115
 
10.6%
2.5619
 
5.9%

Length

2022-05-01T09:18:20.354811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram of lengths of the category

Pie chart

2022-05-01T09:18:20.457811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
ValueCountFrequency (%)
0.04497
42.8%
1.04265
40.6%
2.01115
 
10.6%
2.5619
 
5.9%

Most occurring characters

ValueCountFrequency (%)
No values found.

Most occurring categories

ValueCountFrequency (%)
No values found.

Most frequent character per category

Most occurring scripts

ValueCountFrequency (%)
No values found.

Most frequent character per script

Most occurring blocks

ValueCountFrequency (%)
No values found.

Most frequent character per block

Daily_Avg_mins_spend_on_traveling_page
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct34
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.67358994
Minimum0
Maximum33
Zeros36
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size82.1 KiB
2022-05-01T09:18:20.605814image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3
Q18
median12
Q318
95-th percentile31
Maximum33
Range33
Interquartile range (IQR)10

Descriptive statistics

Standard deviation7.985012874
Coefficient of variation (CV)0.5839734049
Kurtosis-0.1288525779
Mean13.67358994
Median Absolute Deviation (MAD)5
Skewness0.715341989
Sum143518
Variance63.7604306
MonotonicityNot monotonic
2022-05-01T09:18:20.765779image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
10995
 
9.5%
9599
 
5.7%
8585
 
5.6%
6558
 
5.3%
7487
 
4.6%
11475
 
4.5%
13474
 
4.5%
14448
 
4.3%
12441
 
4.2%
15427
 
4.1%
Other values (24)5007
47.7%
ValueCountFrequency (%)
036
 
0.3%
1296
2.8%
2130
 
1.2%
3195
 
1.9%
4304
2.9%
5390
3.7%
6558
5.3%
7487
4.6%
8585
5.6%
9599
5.7%
ValueCountFrequency (%)
33369
3.5%
3295
 
0.9%
3169
 
0.7%
3065
 
0.6%
29127
 
1.2%
28128
 
1.2%
27107
 
1.0%
26126
 
1.2%
25130
 
1.2%
24156
1.5%

Interactions

2022-05-01T09:18:12.040778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:50.761590image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:52.002015image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:53.512502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:55.954459image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:58.375500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:00.619499image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:02.821500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:05.138501image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:07.622462image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:09.779508image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:12.242813image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:50.871644image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:52.133033image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:53.715499image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:56.169467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:58.570517image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:00.808497image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:03.042467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:05.345464image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:07.811500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:09.973499image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:12.445811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:50.974697image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:52.235050image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:53.927506image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:56.392503image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:58.774464image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:00.998500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:03.254466image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:05.560503image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:08.010497image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:10.183214image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:12.653811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:51.075745image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:52.345068image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:54.142500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:56.616503image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:58.987500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:01.312502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:03.467468image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:05.784501image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:08.212502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:10.396815image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:12.870811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:51.207821image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:52.474157image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:54.368463image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:56.849503image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:59.205502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:01.512467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:03.700502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:06.012467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:08.425499image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:10.618815image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:13.075811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:51.322822image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:52.626500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:54.573509image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:57.071500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:59.400499image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:01.704499image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:03.904504image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:06.227463image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:08.617499image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:10.818819image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:13.260815image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:51.428879image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:52.737505image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:54.761465image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:57.269502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:59.591502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:01.871500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:04.091502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:06.418467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:08.793467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:11.003775image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:13.468817image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:51.550875image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:52.861463image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:55.096467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:57.491497image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:59.807461image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:02.067469image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:04.306502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:06.639502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:08.996497image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:11.213776image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:13.802811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:51.677879image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:52.981500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:55.317463image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:57.726500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:00.032503image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:02.269501image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:04.524500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:06.865507image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:09.201501image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:11.428777image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:14.001811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:51.780835image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:53.104500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:55.519503image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:57.932502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:00.222501image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:02.450502image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:04.724499image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:07.068499image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:09.386467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:11.622777image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:14.206778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:51.887899image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:53.307506image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:55.727467image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:17:58.154496image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:00.421505image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:02.634500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:04.934500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:07.285501image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:09.585500image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
2022-05-01T09:18:11.833813image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Correlations

2022-05-01T09:18:21.069778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2022-05-01T09:18:21.498778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2022-05-01T09:18:21.920778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2022-05-01T09:18:22.330813image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.
2022-05-01T09:18:22.615811image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2022-05-01T09:18:14.570778image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
A simple visualization of nullity by column.
2022-05-01T09:18:15.160812image/svg+xmlMatplotlib v3.3.4, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

First rows

df_indexUserIDBuy_ticketYearly_avg_view_on_travel_pagepreferred_devicetotal_likes_on_outstation_checkin_givenyearly_avg_Outstation_checkinsmember_in_familypreferred_location_typeYearly_avg_comment_on_travel_pagetotal_likes_on_outofstation_checkin_receivedweek_since_last_outstation_checkinfollowing_company_pagemontly_avg_comment_on_company_pageworking_flagtravelling_network_ratingnumber_of_adultsDaily_Avg_mins_spend_on_traveling_page
001000001.0Yes307.0Mobile38570.012Financial94.05993.08.0Yes11.0No1.00.08.0
111000002.0No367.0Mobile9765.011Financial61.05130.01.0No23.0Yes4.01.010.0
221000003.0Yes277.0Mobile48055.012Other92.02090.06.0Yes15.0No2.00.07.0
331000004.0No247.0Mobile48720.014Financial56.02909.01.0Yes11.0No3.00.08.0
441000005.0No202.0Mobile20685.011Medical40.03468.09.0No12.0No4.01.06.0
551000006.0No240.0Mobile35175.012Financial79.03068.00.0No13.0No3.00.08.0
681000009.0No285.0Mobile7560.0233Financial44.09526.00.0No21.0Yes2.00.010.0
7101000011.0No262.0Mobile28315.0163Medical84.02426.00.0No13.0No3.01.06.0
8111000012.0No217.0Mobile5355.0152Financial49.04193.00.0Yes12.0No4.00.010.0
9121000013.0No232.0Mobile23450.0261Financial31.02911.01.0No17.0No4.01.05.0

Last rows

df_indexUserIDBuy_ticketYearly_avg_view_on_travel_pagepreferred_devicetotal_likes_on_outstation_checkin_givenyearly_avg_Outstation_checkinsmember_in_familypreferred_location_typeYearly_avg_comment_on_travel_pagetotal_likes_on_outofstation_checkin_receivedweek_since_last_outstation_checkinfollowing_company_pagemontly_avg_comment_on_company_pageworking_flagtravelling_network_ratingnumber_of_adultsDaily_Avg_mins_spend_on_traveling_page
10486117501011751.0No231.0Mobile16423.0284Historical site96.03845.01.0No26.0No2.00.012.0
10487117511011752.0Yes383.0Mobile14399.0283Other58.010910.06.0Yes28.0No2.01.023.0
10488117521011753.0No302.0Mobile25317.0241Other79.012093.00.0No24.0No1.01.029.0
10489117531011754.0No247.0Mobile11418.053Historical site99.09983.01.0No28.0No2.00.016.0
10490117541011755.0No210.0Mobile40886.053Other53.03024.02.0No32.0No4.00.014.0
10491117551011756.0No279.0Laptop30987.0232Historical site58.02616.04.0No36.0No3.01.023.0
10492117561011757.0No305.0Mobile21510.061Historical site55.010041.04.0No30.0No1.01.011.0
10493117571011758.0No214.0Mobile5478.043Beach103.06203.03.0Yes40.0Yes2.01.012.0
10494117581011759.0No382.0Laptop35851.023Historical site83.05444.03.0No32.0No4.00.020.0
10495117591011760.0No270.0Mobile22025.083Historical site104.04470.02.0No29.0No1.00.014.0